# Alternate identity table, text file name ALT.CSV
# 
# Column
# sequence Column name  Type     Size  Description
# -------- ------------ -------  ----  ---------------------
# 1        ent_num      number         link to unique listing
# 2        alt_num      number         unique record identifier
# 3        alt_type     text     8     type of alternate identity
#                                      (aka, fka, nka)
# 4        alt_name     text     350   alternate identity name
# 5        alt_remarks  text     200   remarks on alternate identity

class CreateAlternateNames < ActiveRecord::Migration
  def self.up
    create_table :alternate_names do |t|
      t.integer 'name_id'
      t.string 'alt_type'
      t.string 'alt_name'
      t.string 'remarks'
      t.timestamps
    end
  end

  def self.down
    drop_table :alternate_names
  end
end
